SUPPORT / SAMPLES & SAS NOTES
Problem Note 57564: The Load_STG2DM_Geo_prod_cost_fact job generates "ERROR: Invalid DO loop control information..."
 |  |  |  |
The SAS® Revenue Optimization Load_STG2DM_Geo_prod_cost_fact job might generate the following errors in the <DDMONYYYY_HH_MM_SS>Load_STG2DM_Geo_prod_cost_fact..etl_exec_job.<n>.log file:
NOTE: Argument 1 to function ATTRN at line 422 column 85 is invalid.
ERROR: Invalid DO loop control information, either the INITIAL or TO expression
is missing or the BY expression is missing, zero, or invalid.
dsid=0 num=. i=1 name= len_excp_msg1=. rc=. _ERROR_=1 _N_=1
NOTE: Mathematical operations could not be performed at the following places. The results of
the operations have been set to missing values.
Each place is given by: (Number of times) at (Line):(Column).
1 at 422:85
NOTE: The SAS System stopped processing this step because of errors.
....
len_excp_msg1=
ERROR: Variable ETLS_EXCEPTION_COND not found in di_mon.STG_GEO_PROD_COST_X table
...
ERROR: Execution terminated by an %ABORT statement.
SYMBOLGEN: Macro variable JOB_ID resolves to <n>
SYMBOLGEN: Macro variable SYSCC resolves to 20000
SYMBOLGEN: Macro variable JOB_ID resolves to <n>
SYMBOLGEN: Macro variable MP_UNITS_PROCESSED resolves to <n>
SYMBOLGEN: Macro variable SYSCC resolves to 20000
UNIT INFO: Completed Processing SYSCC = 20000
The errors are generated because the job is unable to open the DI_MON.STG_GEO_PROD_COST_X table. If other unit jobs are able to successfully open the DI_MON.STG_GEO_PROD_COST_X table, then the problem is caused by multiple jobs running concurrently.
To work around this issue, set the NUM_PARALLEL_EXECUTIONS global setting to 1 to prevent multiple Load_STG2DM_Geo_prod_cost unit jobs from running concurrently.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Markdown Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| SAS System | SAS Retail Forecasting | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Windows 7 Ultimate x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||